To Add SQL Statements

Select a specific feature from the Features list. Make sure this feature has database properties as defined in Defining Feature Properties.

Right-click the feature and select Add > SQL Statements.

Note: This option will not be available if an SQL Statements node is already present for the feature.

Select the desired items in the Load SQL Lists and click OK.

This will create an SQL Statements node with a set of SQL statements defined for the properties in this feature. These statements are used executed whenever the appropriate operation in OpenCities Map is selected.

Note: These statements can be edited to suit the application and more than one SQL statement could be provided. Adding more properties to this feature will require to add those properties to the SQL statements. To do so automatically, right-click the SQL Statements node and select Update.

CAUTION: Updating will remove any customization made previously to the SQL statements.